/*
Navicat Premium Data Transfer

Source Server         : localhost
Source Server Type    : MySQL
Source Server Version : 80032 (8.0.32)
Source Host           : localhost:3306
Source Schema         : ruoyi_admin

Target Server Type    : MySQL
Target Server Version : 80032 (8.0.32)
File Encoding         : 65001

Date: 03/01/2024 10:43:03
 */
SET
  NAMES utf8mb4;

SET
  FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;

CREATE TABLE
  `sys_config` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `config_name` VARCHAR(100) DEFAULT '' COMMENT '参数名称',
    `config_key` VARCHAR(100) DEFAULT '' COMMENT '参数键名',
    `config_value` VARCHAR(500) DEFAULT '' COMMENT '参数键值',
    `config_type` CHAR(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` VARCHAR(500) DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 100 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '参数配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_config` (
    `id`,
    `config_name`,
    `config_key`,
    `config_value`,
    `config_type`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1,
    '基础-单客户端登录',
    'sys.base.soloLogin',
    '0',
    'Y',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    '启用 0、停用 1'
  );

INSERT INTO
  `sys_config` (
    `id`,
    `config_name`,
    `config_key`,
    `config_value`,
    `config_type`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    2,
    '用户管理-账号初始密码',
    'sys.user.initPassword',
    '123456',
    'Y',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    '初始化密码 123456'
  );

COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;

CREATE TABLE
  `sys_dept` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `parent_id` BIGINT DEFAULT '0' COMMENT '上级主键',
    `ancestors` VARCHAR(50) DEFAULT '' COMMENT '祖级列表',
    `dept_name` VARCHAR(30) DEFAULT '' COMMENT '部门名称',
    `order_num` INT DEFAULT '0' COMMENT '显示顺序',
    `leader` VARCHAR(20) DEFAULT NULL COMMENT '负责人',
    `phone` VARCHAR(11) DEFAULT NULL COMMENT '联系电话',
    `email` VARCHAR(50) DEFAULT NULL COMMENT '邮箱',
    `status` CHAR(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `del_flag` CHAR(1) DEFAULT '0' COMMENT '删除标志（0存在 2删除）',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 200 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    100,
    0,
    '0',
    '若依科技',
    0,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    101,
    100,
    '0,100',
    '深圳总公司',
    1,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    102,
    100,
    '0,100',
    '长沙分公司',
    2,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    103,
    101,
    '0,100,101',
    '研发部门',
    1,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    104,
    101,
    '0,100,101',
    '市场部门',
    2,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    105,
    101,
    '0,100,101',
    '测试部门',
    3,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    106,
    101,
    '0,100,101',
    '财务部门',
    4,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    107,
    101,
    '0,100,101',
    '运维部门',
    5,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    108,
    102,
    '0,100,102',
    '市场部门',
    1,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

INSERT INTO
  `sys_dept` (
    `id`,
    `parent_id`,
    `ancestors`,
    `dept_name`,
    `order_num`,
    `leader`,
    `phone`,
    `email`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`
  )
VALUES
  (
    109,
    102,
    '0,100,102',
    '财务部门',
    2,
    '若依',
    '15888888888',
    'ry@qq.com',
    '0',
    '0',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL
  );

COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;

CREATE TABLE
  `sys_dict_data` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `dict_sort` INT DEFAULT '0' COMMENT '显示顺序',
    `dict_label` VARCHAR(100) DEFAULT '' COMMENT '字典标签',
    `dict_value` VARCHAR(100) DEFAULT '' COMMENT '字典键值',
    `dict_type` VARCHAR(100) DEFAULT '' COMMENT '字典类型',
    `is_default` CHAR(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
    `status` CHAR(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` VARCHAR(500) DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 100 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_dict_data` (
    `id`,
    `dict_sort`,
    `dict_label`,
    `dict_value`,
    `dict_type`,
    `is_default`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (1, 1, '男', '0', 'sys_user_sex', 'Y', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '性别男');

INSERT INTO
  `sys_dict_data` (
    `id`,
    `dict_sort`,
    `dict_label`,
    `dict_value`,
    `dict_type`,
    `is_default`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (2, 2, '女', '1', 'sys_user_sex', 'N', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '性别女');

INSERT INTO
  `sys_dict_data` (
    `id`,
    `dict_sort`,
    `dict_label`,
    `dict_value`,
    `dict_type`,
    `is_default`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (3, 3, '未知', '2', 'sys_user_sex', 'N', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '性别未知');

INSERT INTO
  `sys_dict_data` (
    `id`,
    `dict_sort`,
    `dict_label`,
    `dict_value`,
    `dict_type`,
    `is_default`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (4, 1, '正常', '0', 'sys_normal_disable', 'Y', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '正常状态');

INSERT INTO
  `sys_dict_data` (
    `id`,
    `dict_sort`,
    `dict_label`,
    `dict_value`,
    `dict_type`,
    `is_default`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (5, 2, '停用', '1', 'sys_normal_disable', 'N', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '停用状态');

INSERT INTO
  `sys_dict_data` (
    `id`,
    `dict_sort`,
    `dict_label`,
    `dict_value`,
    `dict_type`,
    `is_default`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (6, 1, '是', 'Y', 'sys_yes_no', 'Y', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '系统默认是');

INSERT INTO
  `sys_dict_data` (
    `id`,
    `dict_sort`,
    `dict_label`,
    `dict_value`,
    `dict_type`,
    `is_default`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (7, 2, '否', 'N', 'sys_yes_no', 'N', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '系统默认否');

COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;

CREATE TABLE
  `sys_dict_type` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `dict_name` VARCHAR(100) DEFAULT '' COMMENT '字典名称',
    `dict_type` VARCHAR(100) DEFAULT '' COMMENT '字典类型',
    `status` CHAR(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` VARCHAR(500) DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`),
    UNIQUE KEY `dict_type` (`dict_type`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 100 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_dict_type` (
    `id`,
    `dict_name`,
    `dict_type`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (1, '用户性别', 'sys_user_sex', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '用户性别列表');

INSERT INTO
  `sys_dict_type` (
    `id`,
    `dict_name`,
    `dict_type`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (2, '系统开关', 'sys_normal_disable', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '系统开关列表');

INSERT INTO
  `sys_dict_type` (
    `id`,
    `dict_name`,
    `dict_type`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (3, '系统是否', 'sys_yes_no', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '系统是否列表');

COMMIT;

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;

CREATE TABLE
  `sys_login_log` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `user_name` VARCHAR(50) DEFAULT '' COMMENT '用户账号',
    `login_ip` VARCHAR(128) DEFAULT '' COMMENT '登录IP',
    `login_location` VARCHAR(255) DEFAULT '' COMMENT '登录地点',
    `browser` VARCHAR(50) DEFAULT '' COMMENT '浏览器',
    `os` VARCHAR(50) DEFAULT '' COMMENT '操作系统',
    `status` CHAR(1) DEFAULT '0' COMMENT '状态（0成功 1失败）',
    `msg` VARCHAR(255) DEFAULT '' COMMENT '提示消息',
    `login_date` datetime DEFAULT NULL COMMENT '访问时间',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 18 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '登录日志表';

-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
BEGIN;

COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE
  `sys_menu` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `menu_name` VARCHAR(50) NOT NULL COMMENT '菜单名称',
    `parent_id` BIGINT DEFAULT '0' COMMENT '上级主键',
    `order_num` INT DEFAULT '0' COMMENT '显示顺序',
    `path` VARCHAR(200) DEFAULT '' COMMENT '路由地址',
    `component` VARCHAR(255) DEFAULT NULL COMMENT '组件路径',
    `redirect` VARCHAR(255) DEFAULT NULL COMMENT '路由重定向地址',
    `is_frame` CHAR(1) DEFAULT '1' COMMENT '是否为外链（0是 1否）',
    `is_cache` CHAR(1) DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
    `menu_type` CHAR(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    `visible` CHAR(1) DEFAULT '0' COMMENT '是否可见（0显示 1隐藏）',
    `status` CHAR(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `perms` VARCHAR(100) DEFAULT NULL COMMENT '权限标识',
    `icon` VARCHAR(100) DEFAULT '' COMMENT '菜单图标',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` VARCHAR(500) DEFAULT '' COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 2001 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1,
    '系统管理',
    0,
    1,
    'system',
    NULL,
    'system/user',
    '1',
    '0',
    'M',
    '0',
    '0',
    '',
    '@local:icon-park-outline:system',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2023-09-05 21:03:20',
    '系统管理目录'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    2,
    '系统监控',
    0,
    2,
    'monitor',
    NULL,
    'monitor/loginLog',
    '1',
    '0',
    'M',
    '0',
    '0',
    '',
    '@local:icon-park-outline:monitor-one',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2023-09-05 21:03:28',
    '系统监控目录'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    100,
    '用户管理',
    1,
    1,
    'user',
    'system/user/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'system:user:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:39:52',
    '用户管理菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    101,
    '角色管理',
    1,
    2,
    'role',
    'system/role/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'system:role:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:39:53',
    '角色管理菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    102,
    '菜单管理',
    1,
    3,
    'menu',
    'system/menu/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'system:menu:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:39:55',
    '菜单管理菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    103,
    '部门管理',
    1,
    4,
    'dept',
    'system/dept/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'system:dept:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:39:56',
    '部门管理菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    104,
    '岗位管理',
    1,
    5,
    'post',
    'system/post/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'system:post:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:39:58',
    '岗位管理菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    105,
    '字典管理',
    1,
    6,
    'dictType',
    'system/dict/type/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'system:dict:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:39:59',
    '字典管理菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    106,
    '参数配置',
    1,
    7,
    'config',
    'system/config/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'system:config:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:40:01',
    '参数配置菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    107,
    '登录日志',
    2,
    7,
    'loginLog',
    'monitor/loginLog/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'monitor:loginLog:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:40:02',
    '登录日志菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    108,
    '在线用户',
    2,
    8,
    'online',
    'monitor/online/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'monitor:online:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:40:03',
    '在线用户菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    109,
    '操作日志',
    2,
    9,
    'operLog',
    'monitor/operLog/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'monitor:operLog:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:40:03',
    '操作日志菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    112,
    '缓存列表',
    2,
    12,
    'cacheList',
    'monitor/cacheList/index',
    '',
    '1',
    '1',
    'C',
    '0',
    '0',
    'monitor:cache:list',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:40:05',
    '缓存列表菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    113,
    '分配用户',
    1,
    13,
    'roleAuth/:id',
    'system/roleAuth/index',
    '',
    '1',
    '1',
    'C',
    '1',
    '0',
    '',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:40:06',
    '分配用户菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    114,
    '字典数据',
    1,
    14,
    'dictData/:id',
    'system/dict/data/index',
    '',
    '1',
    '1',
    'C',
    '1',
    '0',
    '',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-03 10:40:08',
    '字典数据菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    115,
    '服务监控',
    2,
    13,
    'server',
    'monitor/server/index',
    NULL,
    '1',
    '1',
    'C',
    '0',
    '0',
    'monitor:server:list',
    '',
    'admin',
    '2023-10-26 20:46:30',
    '',
    '2024-01-03 10:40:09',
    '服务监控菜单'
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1001,
    '用户新增',
    100,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:user:add',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1002,
    '用户修改',
    100,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:user:edit',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1003,
    '用户删除',
    100,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:user:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1004,
    '用户导出',
    100,
    5,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:user:export',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1005,
    '用户导入',
    100,
    6,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:user:import',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1006,
    '重置密码',
    100,
    7,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:user:resetPwd',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1008,
    '角色新增',
    101,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:role:add',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1009,
    '角色修改',
    101,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:role:edit',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1010,
    '角色删除',
    101,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:role:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1011,
    '角色导出',
    101,
    5,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:role:export',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1013,
    '菜单新增',
    102,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:menu:add',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1014,
    '菜单修改',
    102,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:menu:edit',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1015,
    '菜单删除',
    102,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:menu:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1017,
    '部门新增',
    103,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:dept:add',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1018,
    '部门修改',
    103,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:dept:edit',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1019,
    '部门删除',
    103,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:dept:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1021,
    '岗位新增',
    104,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:post:add',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1022,
    '岗位修改',
    104,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:post:edit',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1023,
    '岗位删除',
    104,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:post:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1024,
    '岗位导出',
    104,
    5,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:post:export',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1026,
    '字典新增',
    105,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:dict:add',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1027,
    '字典修改',
    105,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:dict:edit',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1028,
    '字典删除',
    105,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:dict:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1029,
    '字典导出',
    105,
    5,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:dict:export',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1031,
    '配置新增',
    106,
    1,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:config:add',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1032,
    '配置修改',
    106,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:config:edit',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1033,
    '配置删除',
    106,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:config:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1034,
    '配置导出',
    106,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'system:config:export',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1043,
    '登录日志删除',
    107,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'monitor:loginLog:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1044,
    '登录日志导出',
    107,
    3,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'monitor:loginLog:export',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1045,
    '用户下线',
    108,
    4,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'monitor:online:delete',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1046,
    '操作日志导出',
    109,
    1,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'monitor:operLog:export',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

INSERT INTO
  `sys_menu` (
    `id`,
    `menu_name`,
    `parent_id`,
    `order_num`,
    `path`,
    `component`,
    `redirect`,
    `is_frame`,
    `is_cache`,
    `menu_type`,
    `visible`,
    `status`,
    `perms`,
    `icon`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1047,
    '操作日志删除',
    109,
    2,
    '',
    '',
    '',
    '1',
    '0',
    'F',
    '0',
    '0',
    'monitor:operLog:remove',
    '',
    'admin',
    '2023-08-19 08:32:40',
    '',
    NULL,
    ''
  );

COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;

CREATE TABLE
  `sys_post` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `post_code` VARCHAR(64) NOT NULL COMMENT '岗位编码',
    `post_name` VARCHAR(50) NOT NULL COMMENT '岗位名称',
    `post_sort` INT NOT NULL COMMENT '显示顺序',
    `status` CHAR(1) NOT NULL COMMENT '状态（0正常 1停用）',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` VARCHAR(500) DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_post` (
    `id`,
    `post_code`,
    `post_name`,
    `post_sort`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (1, 'ceo', '董事长', 1, '0', 'admin', '2023-08-19 08:32:40', '', NULL, '');

INSERT INTO
  `sys_post` (
    `id`,
    `post_code`,
    `post_name`,
    `post_sort`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (2, 'se', '项目经理', 2, '0', 'admin', '2023-08-19 08:32:40', '', NULL, '');

INSERT INTO
  `sys_post` (
    `id`,
    `post_code`,
    `post_name`,
    `post_sort`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (3, 'hr', '人力资源', 3, '0', 'admin', '2023-08-19 08:32:40', '', NULL, '');

INSERT INTO
  `sys_post` (
    `id`,
    `post_code`,
    `post_name`,
    `post_sort`,
    `status`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (4, 'user', '普通员工', 4, '0', 'admin', '2023-08-19 08:32:40', '', NULL, '');

COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE
  `sys_role` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `role_name` VARCHAR(30) NOT NULL COMMENT '角色名称',
    `role_key` VARCHAR(100) NOT NULL COMMENT '角色权限字符串',
    `role_sort` INT NOT NULL COMMENT '显示顺序',
    `status` CHAR(1) NOT NULL COMMENT '状态（0正常 1停用）',
    `del_flag` CHAR(1) DEFAULT '0' COMMENT '删除标志（0存在 2删除）',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` VARCHAR(500) DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 100 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_role` (
    `id`,
    `role_name`,
    `role_key`,
    `role_sort`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (1, '超级管理员', 'admin', 1, '0', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '超级管理员');

INSERT INTO
  `sys_role` (
    `id`,
    `role_name`,
    `role_key`,
    `role_sort`,
    `status`,
    `del_flag`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (2, '普通角色', 'common', 2, '0', '0', 'admin', '2023-08-19 08:32:40', '', NULL, '普通角色');

COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;

CREATE TABLE
  `sys_role_dept` (
    `role_id` BIGINT NOT NULL COMMENT '角色主键',
    `dept_id` BIGINT NOT NULL COMMENT '部门主键',
    PRIMARY KEY (`role_id`, `dept_id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_role_dept` (`role_id`, `dept_id`)
VALUES
  (2, 100);

INSERT INTO
  `sys_role_dept` (`role_id`, `dept_id`)
VALUES
  (2, 101);

INSERT INTO
  `sys_role_dept` (`role_id`, `dept_id`)
VALUES
  (2, 105);

COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;

CREATE TABLE
  `sys_role_menu` (
    `role_id` BIGINT NOT NULL COMMENT '角色主键',
    `menu_id` BIGINT NOT NULL COMMENT '菜单主键',
    PRIMARY KEY (`role_id`, `menu_id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 2);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 100);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 101);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 102);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 103);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 104);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 105);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 106);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 107);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 108);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 109);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1001);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1002);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1003);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1004);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1005);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1006);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1008);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1009);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1010);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1011);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1013);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1014);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1015);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1017);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1018);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1019);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1021);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1022);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1023);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1024);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1026);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1027);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1028);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1029);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1031);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1032);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1033);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1034);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1043);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1044);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1045);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1046);

INSERT INTO
  `sys_role_menu` (`role_id`, `menu_id`)
VALUES
  (2, 1047);

COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE
  `sys_user` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
    `dept_id` BIGINT DEFAULT NULL COMMENT '部门主键',
    `user_name` VARCHAR(30) NOT NULL COMMENT '用户账号',
    `nick_name` VARCHAR(30) NOT NULL COMMENT '用户昵称',
    `email` VARCHAR(50) DEFAULT '' COMMENT '用户邮箱',
    `phone` VARCHAR(11) DEFAULT '' COMMENT '手机号码',
    `sex` CHAR(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
    `avatar` VARCHAR(100) DEFAULT '' COMMENT '头像地址',
    `password` VARCHAR(100) DEFAULT NULL COMMENT '用户密码',
    `status` CHAR(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `del_flag` CHAR(1) DEFAULT '0' COMMENT '删除标志（0存在 2删除）',
    `login_ip` VARCHAR(128) DEFAULT '' COMMENT '最后登录 IP',
    `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
    `create_by` VARCHAR(64) DEFAULT '' COMMENT '创建者',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` VARCHAR(64) DEFAULT '' COMMENT '更新者',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark` VARCHAR(500) DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 100 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_user` (
    `id`,
    `dept_id`,
    `user_name`,
    `nick_name`,
    `email`,
    `phone`,
    `sex`,
    `avatar`,
    `password`,
    `status`,
    `del_flag`,
    `login_ip`,
    `login_date`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    1,
    103,
    'admin',
    '若依',
    'ry@163.com',
    '15888888888',
    '1',
    '',
    '$2b$10$8McBiQcPBE.kxRQ8QsDMo.3GhD.BCd6/l5/HoDi54Ywd10v5f8.di',
    '0',
    '0',
    '127.0.0.1',
    '2024-01-01 21:13:44',
    'admin',
    '2023-08-19 08:32:40',
    '',
    '2024-01-01 21:13:44',
    ''
  );

INSERT INTO
  `sys_user` (
    `id`,
    `dept_id`,
    `user_name`,
    `nick_name`,
    `email`,
    `phone`,
    `sex`,
    `avatar`,
    `password`,
    `status`,
    `del_flag`,
    `login_ip`,
    `login_date`,
    `create_by`,
    `create_time`,
    `update_by`,
    `update_time`,
    `remark`
  )
VALUES
  (
    2,
    105,
    'ry',
    '若依',
    '',
    '',
    '0',
    '',
    '$2b$10$zHJw573GrVYb71spBaxUDuVsY9miw1XOeH56AlZSiGkvB6XjcJtbW',
    '0',
    '0',
    '',
    NULL,
    '',
    '2023-08-19 08:32:40',
    '',
    '2023-11-25 19:13:51',
    ''
  );

COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;

CREATE TABLE
  `sys_user_post` (
    `user_id` BIGINT NOT NULL COMMENT '用户主键',
    `post_id` BIGINT NOT NULL COMMENT '岗位主键',
    PRIMARY KEY (`user_id`, `post_id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与岗位关联表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_user_post` (`user_id`, `post_id`)
VALUES
  (1, 1);

INSERT INTO
  `sys_user_post` (`user_id`, `post_id`)
VALUES
  (2, 2);

COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;

CREATE TABLE
  `sys_user_role` (
    `user_id` BIGINT NOT NULL COMMENT '用户主键',
    `role_id` BIGINT NOT NULL COMMENT '角色主键',
    PRIMARY KEY (`user_id`, `role_id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;

INSERT INTO
  `sys_user_role` (`user_id`, `role_id`)
VALUES
  (1, 1);

INSERT INTO
  `sys_user_role` (`user_id`, `role_id`)
VALUES
  (2, 2);

COMMIT;

SET
  FOREIGN_KEY_CHECKS = 1;

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE if EXISTS `sys_oper_log`;

CREATE TABLE
  `sys_oper_log` (
    `id` BIGINT (20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
    `title` VARCHAR(50) DEFAULT '' COMMENT '模块标题',
    `biz_type` CHAR(2) DEFAULT '0' COMMENT '业务类型',
    `method` VARCHAR(100) DEFAULT '' COMMENT '方法名称',
    `request_method` VARCHAR(10) DEFAULT '' COMMENT '请求方式',
    `request_url` VARCHAR(255) DEFAULT '' COMMENT '请求地址',
    `request_params` VARCHAR(2000) DEFAULT '' COMMENT '请求参数',
    `request_result` VARCHAR(2000) DEFAULT '' COMMENT '请求结果',
    `oper_name` VARCHAR(50) DEFAULT '' COMMENT '操作人员',
    `dept_name` VARCHAR(50) DEFAULT '' COMMENT '部门名称',
    `oper_ip` VARCHAR(128) DEFAULT '' COMMENT '主机地址',
    `oper_location` VARCHAR(255) DEFAULT '' COMMENT '操作地点',
    `status` CHAR(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
    `error_msg` VARCHAR(2000) DEFAULT '' COMMENT '错误消息',
    `oper_time` datetime COMMENT '操作时间',
    `cost_time` BIGINT (20) DEFAULT 0 COMMENT '消耗时间',
    PRIMARY key (`id`),
    key idx_sys_oper_log_bt (`biz_type`),
    key idx_sys_oper_log_s (`status`),
    key idx_sys_oper_log_ot (`oper_time`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 100 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录';